nce youve created the new module we can start writing a Macro:

    We always start with Sub NameOfTheSubroutine () and end with End Sub
    We would write our code in-between those lines. For example:

Sub Advanced Filtering ()
End Sub

Here is the start of our VBA code that would go in between the lines above:

    The "Database" would be replaced with the range area of our data
    The "Criteria" would be replaced by our Criteria range

Range("Database").AdvancedFilter _ 
Action:=xlFilterInPlace, _ 
CriteriaRange:=Range("Criteria")

VBA Code so far:

Sub Advanced_Filtering() 

Range("C6:F23").AdvancedFilter _ 
Action:=xlFilterInPlace, _ 
CriteriaRange:=Range("C2:F3") 

End Sub

We now need to add a button:

    Insert ? Shape ? Pick a Shape and draw it onto the sheet. In this case, well use a rectangle.
